UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S0Yy0ECWI05/+Cnmfsev7ZIGFnIEtyKDugTDDnvbe2E='
WHERE
key_id = 'd7589f5603abc0365a37171ddf3efe4ebb76138daeacf8989da542f0ce368764'
AND (
token = 'S0Yy0ECWI05/+Cnmfsev7ZIGFnIEtyKDugTDDnvbe2E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)