UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XyBXxMqYFGPYgSqo8n6PAak7s2scihXo/zXeNtPcBcY='
WHERE
key_id = 'b8929cb43b0bf3a355864d90c2d28595dc8b49b2f0fcd54fee4fd819d0d4228f'
AND (
token = 'XyBXxMqYFGPYgSqo8n6PAak7s2scihXo/zXeNtPcBcY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)