UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oHQBc8t429qiWt85SqtJ0M0fYzUgsqzVMPkRH8sxYqM='
WHERE
key_id = '0ce1c36769f6648f5409b4b535642b24f80a5a54671542dc6b7afb73861a5b2f'
AND (
token = 'oHQBc8t429qiWt85SqtJ0M0fYzUgsqzVMPkRH8sxYqM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)