UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '16CbAp2Hue5Sw5nEpdZfcln3Sq7bI3R2gQ57JWjxV6U='
WHERE
key_id = 'a08b7be83f56d8450a230946bd0ae7b2840e3b56298612de24d1efc08e8f84fe'
AND (
token = '16CbAp2Hue5Sw5nEpdZfcln3Sq7bI3R2gQ57JWjxV6U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)