UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JbXFoCJ2koNYpmEW6Su9YFFWqomy3+xIdv7WqUqWEYw='
WHERE
key_id = 'e09357b568abab05385aa24ab1ab2c8497a4d3b8f66040cf1754196b9cd08d29'
AND (
token = 'JbXFoCJ2koNYpmEW6Su9YFFWqomy3+xIdv7WqUqWEYw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)