UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mff6LXazI+uwKVeFnxt/5tmUaJrNfKODMX2CtHxa4Us='
WHERE
key_id = 'dd004129dad416be689995577fe2f8d5781bf6fffbbde3082035ca914afea8f3'
AND (
token = 'mff6LXazI+uwKVeFnxt/5tmUaJrNfKODMX2CtHxa4Us='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)