UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XZORvFp525DmCZAAflBjCtvPVyWsHFq8GQ8hN/nUtjk='
WHERE
key_id = 'f9fe339088bd1f1a036f3dd3833440f5c4a993f20b47879fd3e7ae3bc64748c9'
AND (
token = 'XZORvFp525DmCZAAflBjCtvPVyWsHFq8GQ8hN/nUtjk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)