UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QJ0AE/2FbuFgs1OUuY4d26S48XBhNCSXRa7+rAs6Fpc='
WHERE
key_id = 'b67bece8215d1e11a2d31bcff0af8af6b30d040d87504c19618ba88e340ebfe6'
AND (
token = 'QJ0AE/2FbuFgs1OUuY4d26S48XBhNCSXRa7+rAs6Fpc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)