UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd/cDVEYAb0kWZXwMWTnPNsYO25kSIgaIRCl5795OEoM='
WHERE
key_id = '5b71456763ff87c6db3ce39679a22df45c44ba0c31c83738f4dd0f8538091a31'
AND (
token = 'd/cDVEYAb0kWZXwMWTnPNsYO25kSIgaIRCl5795OEoM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)