UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x2QSCim8Kt2dSG0JtOkcEucNep05mODxwZiZK5fAMM0='
WHERE
key_id = '517bb8673665f84cadb06f1a8ebb9ebeeb5889cac713573433ae86c720d6a17e'
AND (
token = 'x2QSCim8Kt2dSG0JtOkcEucNep05mODxwZiZK5fAMM0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)