UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pzI0URg4DX1en5pd8xaBv8NA+Zjj3TdKMiCDTqEMuuM='
WHERE
key_id = 'c53d313ec5877833cead08df09f1a46e8337a31dbfe5b474ba79d5fb0378a7ea'
AND (
token = 'pzI0URg4DX1en5pd8xaBv8NA+Zjj3TdKMiCDTqEMuuM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)