UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Do4iyqCAbli8KW5avEoxgwOzyoHnyVMjrDJhRVZ+9j0='
WHERE
key_id = 'b4aaa2ac9eff2836986631a843df0eafef800cee83a047c8035bd5cdf4138839'
AND (
token = 'Do4iyqCAbli8KW5avEoxgwOzyoHnyVMjrDJhRVZ+9j0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)