UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n2a7rkTjQfgLhz8zJrZWBwhLl/AVMGouMmAwoKgU9Yw='
WHERE
key_id = '8d0f6654be82651cf6b3241b6030e67144d9ee035111f0c3be2e00e6851eee48'
AND (
token = 'n2a7rkTjQfgLhz8zJrZWBwhLl/AVMGouMmAwoKgU9Yw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)