UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mOKtk8z1Pi4y9lnEAefeUP8dO0/u83ekPa1dTKGPfig='
WHERE
key_id = 'bcec56e3b56e4420fbdaf39b22ae6597c6b1cc2e6f37f8dca70d927784e6c7b8'
AND (
token = 'mOKtk8z1Pi4y9lnEAefeUP8dO0/u83ekPa1dTKGPfig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)