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