UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LTRP28OGK3YrOr0nFggtd/ChKp+IiFBTUIHONks1wf4='
WHERE
key_id = 'dc25f3018a4f1de12346ce7f37d579e0f8c5f511f39ca1f33d03c9015f93614b'
AND (
token = 'LTRP28OGK3YrOr0nFggtd/ChKp+IiFBTUIHONks1wf4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)