UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wrWaYNclrWsB7zxK8wn1sESkWvHCfUuxyhunMz0gvdM='
WHERE
key_id = 'cddf8da3ef860fa686f3907d631324d02af466ce635490d69e3b298b5fb61afb'
AND (
token = 'wrWaYNclrWsB7zxK8wn1sESkWvHCfUuxyhunMz0gvdM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)