UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '93zfVwoA+EQny0S0U0qCMYlVtvfWnU59two4WmKrJ3Y='
WHERE
key_id = 'bdb57da8cf072cd4724b6776399400f08ba286bbfad53435f4da204f9ec68c1c'
AND (
token = '93zfVwoA+EQny0S0U0qCMYlVtvfWnU59two4WmKrJ3Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)