UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VNBq8gYeSaypSdBgUkTSi4TlcNf2KN7+qcJKb5zJs4Q='
WHERE
key_id = 'a988ae90627f9d6591d08167a4fd9d26de5e5220751adc5815ddbea7ff55ea47'
AND (
token = 'VNBq8gYeSaypSdBgUkTSi4TlcNf2KN7+qcJKb5zJs4Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)