UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XYxLAhVlCRQsWqoC2fKKmQYUd9xGPVrcInW1dPptHZY='
WHERE
key_id = 'bd7488e24656e8061c983848ec272e1942ed98fbedb507ece96c4436542a04df'
AND (
token = 'XYxLAhVlCRQsWqoC2fKKmQYUd9xGPVrcInW1dPptHZY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)