UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nwISUO/dwfd+8bIOtMYU+V+G7W+UGiBeegAZoVr9Yok='
WHERE
key_id = 'b4c5c23037eebe60e754ea0b8067ac6c8fe9dc62b1fcf1a0791714c0c56bd53f'
AND (
token = 'nwISUO/dwfd+8bIOtMYU+V+G7W+UGiBeegAZoVr9Yok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)