UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3DazVXYwhIONLtYBr17gfpADQ35enfH0R06JtvYfSbo='
WHERE
key_id = 'de1c918fb65df7a2eb0e79d157ac261640a8e1e3198626927f4e7d4a858f260c'
AND (
token = '3DazVXYwhIONLtYBr17gfpADQ35enfH0R06JtvYfSbo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)