UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qsHhvM0pDMEYOwluCN6nWBka6ah49tlLGnQCx6tjIjA='
WHERE
key_id = '4f0016b4bebfeda3d47656a677100f7fd7beb2d7e28e30c4394e978dc334d23b'
AND (
token = 'qsHhvM0pDMEYOwluCN6nWBka6ah49tlLGnQCx6tjIjA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)