UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1TgfH3xICcAA35bSuXjgcj1NZXHg2N3h168ApLPOUjA='
WHERE
key_id = '11721c687c0f9b3348bbd87166ad8ee26b5ce2d91b0b47f037e917ef7fab167e'
AND (
token = '1TgfH3xICcAA35bSuXjgcj1NZXHg2N3h168ApLPOUjA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)