UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X0KNFq9IoJBZhxb0awa6Ra9r7t60fg4iSBcdr3Dbgo0='
WHERE
key_id = 'f3543a3e18f82001747d11d514f05de7a30f5ca73e05902ad051947d7df75880'
AND (
token = 'X0KNFq9IoJBZhxb0awa6Ra9r7t60fg4iSBcdr3Dbgo0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)