UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6s6ugXlENTttHKFCfoYijq0A6ZcTXrdmULd9W69b1V8='
WHERE
key_id = '6a744199264663de2563aafb9fc1abfeddf208728239f15b0894d64f4186a488'
AND (
token = '6s6ugXlENTttHKFCfoYijq0A6ZcTXrdmULd9W69b1V8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)