UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oNuj8b8zCz0ouoMNLflW0+f4Tom50uFwZbHFww5TAI4='
WHERE
key_id = '7d700c1c51c90cf74bb867f25be0f6085949a3516dc099433ac4b55230e68414'
AND (
token = 'oNuj8b8zCz0ouoMNLflW0+f4Tom50uFwZbHFww5TAI4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)