UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WpA7sLzfn7Sj5L7QU9c5Gw+AZb8n191JMs3XVPrhWx0='
WHERE
key_id = 'bb2d5c8839d72c69cf3a0c4dceb2f463fde067a4a6266732cc2cea4d29ce6d4b'
AND (
token = 'WpA7sLzfn7Sj5L7QU9c5Gw+AZb8n191JMs3XVPrhWx0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)