UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xdY+ppgEw2Inlo1kfVuRoh6RgOdLy6rVMGWB79KGGZU='
WHERE
key_id = 'aa91495b6bdb6f96a1672e7c48589b7a08a2af4f79be80392fa696f08b5ab0cd'
AND (
token = 'xdY+ppgEw2Inlo1kfVuRoh6RgOdLy6rVMGWB79KGGZU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)